﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_USER_TASK_HISTORY_CLASSIFICATION_SE')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_USER_TASK_HISTORY_CLASSIFICATION_SE
	END

GO

CREATE Procedure dbo.PRC_TB_USER_TASK_HISTORY_CLASSIFICATION_SE

AS

select
	TUHC_ID,
	TUHC_DESCRIPTION
from TB_USER_TASK_HISTORY_CLASSIFICATION
order by TUHC_DESCRIPTION

GO

GRANT EXEC ON dbo.PRC_TB_USER_TASK_HISTORY_CLASSIFICATION_SE TO PUBLIC

GO
